forum

home / developersection / forums / how to list all tables in a schema in oracle sql?

Ask Question
Utpal Vishwas

Student

I am Utpal Vishwas from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Follow
Can you answer this question?
Answer

1 Answers

Aryan Kumar

Aryan Kumar

18-Jul-2023

Sure, here is how you can list all tables in a schema in Oracle SQL:

SQL

SELECT table_name
FROM user_tables;

This query will select all tables in the current user's schema. The user_tables view is a data dictionary view that contains information about all of the tables in the schema.

The table_name column contains the name of the table.

To run this query, you will need to connect to the Oracle database using a tool like SQLPlus. Once you are connected, you can run the query by typing it into the SQLPlus prompt.

For example, to run the query above, you would type the following into the SQL*Plus prompt:

SQL

SELECT table_name
FROM user_tables;

This would return a list of all tables in the current user's schema.

You can also use the all_tables view to list all tables in the database, including tables that are owned by other users.

Here is the syntax for the all_tables view:

SQL

SELECT table_name
FROM all_tables;

To run this query, you will need to have the DBA role or be granted the SELECT privilege on the all_tables view.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy